--Execute as sys
REM flush.sql

REM Start with a clean slate. Flush the cache and shared pool. 
REM Verify that memory was released.


SET ECHO ON
SET FEEDBACK 1
SET SERVEROUTPUT ON

execute dbms_result_cache.flush
alter system flush shared_pool
/
execute dbms_result_cache.memory_report
/